--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
      name:  <unnamed>
       log:  /a/mcrlx1/lcl/mcr/res_bfi/m1res00/gasprice/replication_archive/placeann_stats.log
  log type:  text
 opened on:  29 Oct 2013, 15:07:35

. 
. use placeann , clear

. 
. drop nplace

. egen mark = tag(newid)

. gen temp = 1 if hu80~=. & areal90~=. & sfus~=.
(131411 missing values generated)

. egen cdata = mean(temp), by(newid)
(123867 missing values generated)

. drop temp

. egen nplace = count(newid) if mark==1, by(cbsa)
(265320 missing values generated)

. egen nplace2 = count(newid) if mark==1 & cdata==1, by(cbsa)
(271638 missing values generated)

. egen markc = tag(cbsa) if mark==1 & cdata==1

. sum nplace2 if markc==1, det

                           nplace2
-------------------------------------------------------------
      Percentiles      Smallest
 1%            1              1
 5%            1              1
10%            2              1       Obs                 357
25%            3              1       Sum of Wgt.         357

50%            7                      Mean           14.92717
                        Largest       Std. Dev.      31.24658
75%           14            148
90%           29            192       Variance       976.3486
95%           47            293       Skewness       6.699289
99%          148            347       Kurtosis       59.47278

. 
. sum hu80 areal90 avgtime80 if mark==1 & cdata==1, det

                           1aTotHU
-------------------------------------------------------------
      Percentiles      Smallest
 1%           68             10
 5%          146             14
10%          226             23       Obs                5329
25%          515             25       Sum of Wgt.        5329

50%         1465                      Mean            7030.42
                        Largest       Std. Dev.      29697.12
75%         4728         471412
90%        14149         678324       Variance       8.82e+08
95%        25870         685629       Skewness       19.89567
99%        84080        1189475       Kurtosis       608.3862

                          AREALAND
-------------------------------------------------------------
      Percentiles      Smallest
 1%         .355           .096
 5%         .833           .119
10%        1.281           .121       Obs                5329
25%        2.674           .127       Sum of Wgt.        5329

50%        6.853                      Mean           23.51893
                        Largest       Std. Dev.      70.85369
75%       19.461       1215.588
90%       53.368       1398.284       Variance       5020.245
95%       87.286       1575.122       Skewness       12.63875
99%       260.68        1964.95       Kurtosis       238.0306

                          avgtime80
-------------------------------------------------------------
      Percentiles      Smallest
 1%      10.9976       5.056338
 5%     13.40658       5.918919
10%      14.7787       6.130435       Obs                5325
25%     17.05842            6.3       Sum of Wgt.        5325

50%     20.11628                      Mean           20.77554
                        Largest       Std. Dev.      5.311077
75%     23.66908       44.90488
90%     27.60226       44.93775       Variance       28.20754
95%      30.3607       46.47887       Skewness       .8301822
99%     37.02317       51.74453       Kurtosis       4.414571

. 
. sum sfus if cdata==1, det

                            sfus
-------------------------------------------------------------
      Percentiles      Smallest
 1%            0              0
 5%            0              0
10%            0              0       Obs              145556
25%     .0011291              0       Sum of Wgt.      145556

50%     .0059698                      Mean           .0163088
                        Largest       Std. Dev.      .0380992
75%     .0173073       2.133443
90%     .0402117       2.171756       Variance       .0014515
95%     .0642023       2.205323       Skewness       16.17536
99%     .1505569       2.503443       Kurtosis       617.9572

. 
. 
. quietly log off
